Create “ Traffic Collison” Chart 17

Step 1:  Creating a chart based on the previous Chart (Time Chart).


1.     Copy and paste " Time” Chart. Use Ctrl V to paste the chart

2.     Delete the "Month, Year, Day, Holiday " From the shared axis 

3.     Drag and drop "Passenger type" column to the shared axis 


Step 2: Configure the “Traffic Collision” chart

                Click on the Format icon on the visualization bar

a. General Tab

·         X- Position: 505

·         Y Position: 432

·         Width: 329

·         Height: 289

·         Legend: ON

·         Position: Top

·         Title: OFF

 

b. Configure the X axis: ON

·         Keep the same format from the previous Chart (Time Chart). 

c. Configure the Y- axis

1. Y-axis (Column)

·         Position: Left

·         Scale type: Liner

·         Start: -20

·         End: Auto

·         Keep the same format for the rest from the previous (time chart)

2. Y- axis (Line)

·         Position: Right

·         Start: -0.1

·         End: Auto

·         Keep the same format the rest.

3.  Keep the same Format for Data Color, Data Label, Shape, Background, and Boarder, Change only the title to “Traffic Collision”.


Follow the gif below to format the “Traffic Collision” Chart 




To learn More about how to create combo line and stacked chart visual in Power BI, click the link below:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart